Evaluate(Object[],Object) Method

In This Topic

Returns a value or the reference to a value from within a table or range.

Syntax

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object, _
   ByVal context As Object _
) As Object

'Usage
 
Dim instance As CalcIndexFunction
Dim args() As Object
Dim context As Object
Dim value As Object
 
value = instance.Evaluate(args, context)

public override object Evaluate( 
   object[] args,
   object context
)

args

The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].

Array is a range of cells or an array constant.

Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.

[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.

[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.

context

Context in which the evaluation occurs

A System.Object value that indicates the evaluate result.